var fs = require('fs')
var path = require('path')
var Sequelize = require('sequelize')
var basename = path.basename(module.filename)
var env = process.env.NODE_ENV || 'dev'
var config = require('../config')['mysql']

var db = {}
var sequelize = new Sequelize(
  config.database,
  config.username,
  config.password,
  config
)

const Promise = require('bluebird')
const cls = require('continuation-local-storage')
const ns = cls.createNamespace('my-very-own-namespace')
const clsBluebird = require('cls-bluebird')
clsBluebird(ns, Promise)
Sequelize.useCLS(ns)

fs
  .readdirSync(__dirname)
  .filter(function(file) {
    return (
      file.indexOf('.') !== 0 && file !== basename && file.slice(-3) === '.js'
    )
  })
  .forEach(function(file) {
    var model = sequelize['import'](path.join(__dirname, file))
    db[model.name] = model
  })

Object.keys(db).forEach(function(modelName) {
  if (db[modelName].associate) {
    db[modelName].associate(db)
  }
})

db.sequelize = sequelize
db.Sequelize = Sequelize

module.exports = db
